PROMPT *-*-*-*-*-*-*  dir_1 DIRECTORY creation STARTS... *-*-*-*-*-*-*

CREATE OR REPLACE DIRECTORY dir_1
AS '&&path\Rabiya_Beevi\05_Report_generation\Files';

PROMPT *-*-*-*-*-*-*  dir_1 DIRECTORY creation ENDS... *-*-*-*-*-*-*

PROMPT *-*-*-*-*-*-*  dir_1 permission creation STARTS... *-*-*-*-*-*-*

GRANT all ON DIRECTORY dir_1 TO PUBLIC;

GRANT EXECUTE ON utl_file TO PUBLIC;

PROMPT *-*-*-*-*-*-*  dir_1 permission creation ENDS... *-*-*-*-*-*-*